Airbnb Price Distribution in Seattle

ningze zu

12/17/2018

Abstract

In this project, I will use benford’s law to analysis the distribution of Airbnb listings’ price in Seattle and perform an exploratory data analysis figure out other features that are relevant to the rental price of Airbnb.

Parts

Airbnb Price Distribution

Benford’s Law

Benford’s Law

## 
## Benford object:
##  
## Data: airbnb_se_m$price 
## Number of observations used = 8610 
## Number of obs. for second order = 364 
## First digits analysed = 2
## 
## Mantissa: 
## 
##    Statistic Value
##         Mean  0.48
##          Var  0.11
##  Ex.Kurtosis -1.43
##     Skewness  0.15
## 
## 
## The 5 largest deviations: 
## 
##   digits absolute.diff
## 1     15        239.67
## 2     99        237.42
## 3     10        230.61
## 4     12        227.70
## 5     75        195.47
## 
## Stats:
## 
##  Pearson's Chi-squared test
## 
## data:  airbnb_se_m$price
## X-squared = 7826.1, df = 89, p-value < 2.2e-16
## 
## 
##  Mantissa Arc Test
## 
## data:  airbnb_se_m$price
## L2 = 0.057452, df = 2, p-value < 2.2e-16
## 
## Mean Absolute Deviation: 0.007389969
## Distortion Factor: 2.066781
## 
## Remember: Real data will never conform perfectly to Benford's Law. You should not focus on p-values!

Get Suspects

getSuspects(bf, airbnb_se_m)
##         X       id                                             name
##   1:   30    24212          ★PERFECT Getaway w/ Views★SALE 10/8, 11
##   2:   52   103908                    Green Lake Gem - Walk to Lake
##   3:   61   132160              Green Lake Guest Suite, private apt
##   4:   81   202174               Modern Townhome in Superb Location
##   5:   83   202260      Cozy Seattle Apartment Near UW & Children's
##  ---                                                               
## 752: 8507 28873969            Seattle Home in the heart of the city
## 753: 8547 29002153               High Rise 2bd/2bth home Pike Place
## 754: 8551 29011992 New Rental! Centrally Located & Stylish-Sleeps 4
## 755: 8578 29058863           Seattle Traveler's Home Away from Home
## 756: 8608 29156425                         Spacious Belltown Studio
##       host_id host_is_superhost                     street
##   1:    74305                 f Seattle, WA, United States
##   2:   541406                 f Seattle, WA, United States
##   3:   558743                 t Seattle, WA, United States
##   4:    58235                 f Seattle, WA, United States
##   5:   990195                 f Seattle, WA, United States
##  ---                                                      
## 752: 15402446                 f Seattle, WA, United States
## 753: 19403115                 t seattle, WA, United States
## 754:  2882164                 f Seattle, WA, United States
## 755: 34449930                 f Seattle, WA, United States
## 756: 73405356                 f Seattle, WA, United States
##         neighbourhood_cleansed    city state zipcode country_code latitude
##   1:                  Belltown Seattle    WA      NA           US 47.61540
##   2:                Green Lake Seattle    WA      NA           US 47.68427
##   3:                Green Lake Seattle    WA      NA           US 47.68226
##   4:    International District Seattle    WA      NA           US 47.59605
##   5:                View Ridge Seattle    WA      NA           US 47.68004
##  ---                                                                      
## 752:                  Belltown Seattle    WA      NA           US 47.61649
## 753: Central Business District seattle    WA      NA           US 47.60591
## 754:        Southeast Magnolia Seattle    WA      NA           US 47.64567
## 755:               Lawton Park Seattle    WA      NA           US 47.65275
## 756:                  Belltown Seattle    WA      NA           US 47.61687
##      longitude property_type       room_type accommodates bathrooms
##   1: -122.3487   Condominium Entire home/apt            6         1
##   2: -122.3266     Apartment Entire home/apt            4         1
##   3: -122.3434   Guest suite Entire home/apt            6         1
##   4: -122.3179     Townhouse Entire home/apt            4         2
##   5: -122.2840     Apartment Entire home/apt            2         1
##  ---                                                               
## 752: -122.3444     Apartment Entire home/apt            1         1
## 753: -122.3394     Apartment Entire home/apt            8         2
## 754: -122.3860     Apartment Entire home/apt            4         1
## 755: -122.3867         House Entire home/apt            2         2
## 756: -122.3465     Apartment Entire home/apt            2         1
##      bedrooms beds
##   1:        2    3
##   2:        1    1
##   3:        2    3
##   4:        2    2
##   5:        1    1
##  ---              
## 752:        1    1
## 753:        2    4
## 754:        1    2
## 755:        3    1
## 756:        0    1
##                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             amenities
##   1:                                                                                                                                                                                                                                                                                                           {TV,"Cable TV",Internet,Wifi,"Air conditioning","Wheelchair accessible",Pool,Kitchen,"Free parking on premises",Gym,Elevator,"Hot tub",Heating,"Family/kid friendly",Washer,Dryer,"Smoke detector","Carbon monoxide detector","Fire extinguisher",Essentials,Shampoo,"24-hour check-in",Hangers,"Hair dryer",Iron,"Laptop friendly workspace","Hot water","Long term stays allowed","Host greets you"}
##   2:                                                                                                                                                                                                                                                                                                                                                  {TV,"Cable TV",Internet,Wifi,Kitchen,"Free street parking","Buzzer/wireless intercom",Heating,"Family/kid friendly",Washer,Dryer,"Smoke detector","Carbon monoxide detector","First aid kit","Safety card","Fire extinguisher",Essentials,Shampoo,Hangers,"Hair dryer",Iron,"Laptop friendly workspace","Private entrance","High chair",Crib,"Hot water",Other}
##   3: {TV,Internet,Wifi,"Air conditioning",Kitchen,"Free street parking",Heating,Washer,Dryer,"Smoke detector","Carbon monoxide detector","First aid kit","Fire extinguisher",Essentials,Shampoo,"24-hour check-in",Hangers,"Hair dryer",Iron,"Laptop friendly workspace","translation missing: en.hosting_amenity_49","Self check-in",Keypad,"Private entrance","Room-darkening shades","Hot water","Bed linens","Extra pillows and blankets",Microwave,"Coffee maker",Refrigerator,Dishwasher,"Dishes and silverware","Cooking basics",Oven,Stove,"BBQ grill","Patio or balcony","Luggage dropoff allowed","Wide hallway clearance","Wide doorway","Well-lit path to entrance","Lake access","Handheld shower head"}
##   4:                                                                 {TV,"Cable TV",Internet,Wifi,Kitchen,"Free parking on premises","Smoking allowed","Free street parking",Heating,Washer,Dryer,"Smoke detector","Carbon monoxide detector","Safety card",Essentials,Shampoo,Hangers,"Hair dryer",Iron,"Self check-in",Lockbox,"Private entrance",Bathtub,"Hot water","Bed linens","Extra pillows and blankets","Coffee maker",Refrigerator,Dishwasher,"Dishes and silverware","Cooking basics",Oven,Stove,"BBQ grill","Patio or balcony","Garden or backyard","Luggage dropoff allowed","Long term stays allowed","Step-free access","Flat path to front door","Well-lit path to entrance","Handheld shower head"}
##   5:                                                                                                                                                                                                                                                                            {Internet,Wifi,Kitchen,"Free parking on premises","Pets live on this property",Dog(s),"Indoor fireplace",Heating,Washer,Dryer,"Smoke detector","Carbon monoxide detector","First aid kit","Safety card","Fire extinguisher",Essentials,Shampoo,"24-hour check-in",Hangers,"Hair dryer",Iron,"Laptop friendly workspace","translation missing: en.hosting_amenity_49","translation missing: en.hosting_amenity_50","Private entrance"}
##  ---                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 
## 752:                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              {TV,Wifi,Pool,Kitchen,Gym,Elevator,"Hot tub",Heating,Washer,Dryer,"Smoke detector","Carbon monoxide detector","First aid kit",Essentials,Hangers,"Host greets you"}
## 753:                                                                                                                                                                                                                                                                                                                                                                                                                                                                            {TV,"Cable TV",Internet,Wifi,Kitchen,Breakfast,Heating,Washer,"Smoke detector","Carbon monoxide detector","First aid kit","Fire extinguisher",Essentials,Shampoo,"24-hour check-in",Hangers,"Hair dryer","Laptop friendly workspace"}
## 754:                                                                                                                                                                                                                                                                                                                                                                   {TV,"Cable TV",Wifi,Kitchen,Breakfast,Heating,Washer,Dryer,"Smoke detector","Carbon monoxide detector","First aid kit","Fire extinguisher",Essentials,Shampoo,"Lock on bedroom door",Hangers,"Hair dryer",Iron,"Laptop friendly workspace","Private entrance","Hot water","Bed linens","Extra pillows and blankets","Long term stays allowed"}
## 755:                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                {Wifi,Kitchen,"Free parking on premises",Washer,Dryer,Essentials}
## 756:                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   {Kitchen,"Free parking on premises",Elevator,Heating,Washer,Dryer,"Smoke detector","Carbon monoxide detector",Essentials,"Hair dryer","Hot water","Long term stays allowed","Host greets you"}
##      price security_deposit cleaning_fee minimum_nights maximum_nights
##   1:   157              500          130              1            365
##   2:   150              400          125              3            120
##   3:   150              400           NA              3             10
##   4:   159              200          140              2            730
##   5:    99              185           NA             30            200
##  ---                                                                  
## 752:   150               NA           NA              1           1125
## 753:   155                0          100              1           1125
## 754:    99                0           95              5           1125
## 755:   150               NA           NA              1           1125
## 756:   150              250           25              1           1125
##      availability_365 number_of_reviews review_scores_rating
##   1:              134                76                   94
##   2:              315                17                   94
##   3:              164               237                   97
##   4:                0                18                   97
##   5:                0               143                   98
##  ---                                                        
## 752:                2                 2                   70
## 753:              338                 0                   NA
## 754:               26                 0                   NA
## 755:                1                 0                   NA
## 756:               59                 0                   NA
##              cancellation_policy    Area       neighbourhood
##   1: strict_14_with_grace_period Seattle            Downtown
##   2: strict_14_with_grace_period Seattle Other neighborhoods
##   3: strict_14_with_grace_period Seattle Other neighborhoods
##   4:                    moderate Seattle            Downtown
##   5:                    moderate Seattle Other neighborhoods
##  ---                                                        
## 752:                    flexible Seattle            Downtown
## 753:                    moderate Seattle            Downtown
## 754:                    flexible Seattle            Magnolia
## 755:                    flexible Seattle            Magnolia
## 756:                    moderate Seattle            Downtown

Other Features (Bedrooms)

Other Features (Accommodates)

Other Features (Room Type)

Other Features (Room Type)

Other Features (Neighbourhoods)

Other Features (Neighbourhoods)